package com.ziyun.erp.modules.material.dao;

import com.ziyun.erp.modules.material.entity.MaterialCategoryEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 耗材分类表
 * 
 * @author guizhao
 * @email ...
 * @date 2018-08-08 11:34:35
 */
public interface MaterialCategoryDao extends BaseMapper<MaterialCategoryEntity> {

    void  deleteUpdate(Integer categoryId);

    String selectChildrenCategoryId(String s);

    @Select(" select level from erp_material_category where category_name = #{parentName} ")
    Integer getlevelValue(@Param("parentName") String parentName);
}
